Tabela PhCompanyLocalization

Definicja tabeli PhCompanyLocalization

Name

PhCompanyLocalization

Code

PhCompanyLocalization

Comment

PL: Informacje o róznych lokalizacjach dostawcy


Lista kolumn tabeli PhCompanyLocalization

Name

Code

CompanyLocalizationID

CompanyLocalizationID

CompanyID

CompanyID

AddressID

AddressID

Name

Name

AuthorizationNo

AuthorizationNo

EntityType

EntityType

TaxIdentificationNo

TaxIdentificationNo

LocationEntityType

LocationEntityType

TaxLocationIdentificationNo

TaxLocationIdentificationNo


Kolumna CompanyLocalizationID tabeli PhCompanyLocalization

Definicja kolumny CompanyLocalizationID tabeli PhCompanyLocalization

Name

CompanyLocalizationID

Code

CompanyLocalizationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz Glówny PhSqCompanyLocalization


Kolumna CompanyID tabeli PhCompanyLocalization

Definicja kolumny CompanyID tabeli PhCompanyLocalization

Name

CompanyID

Code

CompanyID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz obcy do tabeli PhCompany


Kolumna AddressID tabeli PhCompanyLocalization

Definicja kolumny AddressID tabeli PhCompanyLocalization

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz obcy do tabeli PhAddress


Kolumna Name tabeli PhCompanyLocalization

Definicja kolumny Name tabeli PhCompanyLocalization

Name

Name

Code

Name

Data Type

NUMBER(10)

Mandatory

No

Comment

Lokalizacja


Kolumna AuthorizationNo tabeli PhCompanyLocalization

Definicja kolumny AuthorizationNo tabeli PhCompanyLocalization

Name

AuthorizationNo

Code

AuthorizationNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer zezwolenia


Kolumna EntityType tabeli PhCompanyLocalization

Definicja kolumny EntityType tabeli PhCompanyLocalization

Name

EntityType

Code

EntityType

Data Type

VARCHAR2(20)

Mandatory

No

Comment

Rodzaj podmiotu


Kolumna TaxIdentificationNo tabeli PhCompanyLocalization

Definicja kolumny TaxIdentificationNo tabeli PhCompanyLocalization

Name

TaxIdentificationNo

Code

TaxIdentificationNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Numer identyfikacji podatkowej podmiotu


Kolumna LocationEntityType tabeli PhCompanyLocalization

Definicja kolumny LocationEntityType tabeli PhCompanyLocalization

Name

LocationEntityType

Code

LocationEntityType

Data Type

VARCHAR2(20)

Mandatory

No

Comment

Rodzaj miejsca prowadzenia dzialalnosci podmiotu


Kolumna TaxLocationIdentificationNo tabeli PhCompanyLocalization

Definicja kolumny TaxLocationIdentificationNo tabeli PhCompanyLocalization

Name

TaxLocationIdentificationNo

Code

TaxLocationIdentificationNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Numer identyfikacji podatkowej miejsca prowadzenia dzialalnosci podmiotu


Lista kluczy tabeli PhCompanyLocalization

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhCompanyLocalization

Definicja klucza Identifier_1 tabeli PhCompanyLocalization

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment